USE [DTP]
GO

/****** Object:  StoredProcedure [dbo].[GetEquipageInfoByID]    Script Date: 11/25/2010 17:50:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[GetAccidentCardInfoByID]
	@AccidentCardID INTEGER

AS
BEGIN
		SELECT *
		
		FROM t_AccidentCards WHERE
		id = @AccidentCardID AND Deleted = 0	 
END

GO


